Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RetailStoreID (FK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | FuelPump(AS_PMP_FUEL) |
RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | RetailStore(PA_STR_RTL) |
FuelingPointID (PK) | A unique identifier for the FuelingPoint at a particular retail store | ID_PNT_FUEL | Identity | integer | |
FuelPumpID (FK) | A unique identifier for the FuelPump | ID_FUEL_PMP | Identity | integer | FuelPump(AS_PMP_FUEL) |
UnitOfMeasureCode (FK) | The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. | CD_UOM | Code | varchar(20) | UnitOfMeasure(CO_UOM) |
WeightsAndMeasuresSoftwareVersion | The software version in the FuellingPoint as reported to Weights & Measures | NM_WM_SW_VN | Name | varchar(40) | |
WeightsAndMeasuresSoftwareDate | The date of the software version in the FuellingPoint as reported to Weights & Measures | CA_WM_SW_DT | DateCalendar | date | |
WeightsAndMeasuresSecurityCode | A security code in the FuellingPoint as reported to Weights & Measures | CD_WM_SCTY | Code | varchar(20) | |
ProtocolVersionCode | The version of the protocol this FuellingPoint uses. | CD_VN_PRTCL | Code | varchar(20) | |